{\rtf1\ansi\ansicpg1252\cocoartf1038\cocoasubrtf290
{\fonttbl\f0\fmodern\fcharset0 CourierNewPSMT;\f1\fmodern\fcharset0 CourierNewPS-BoldItalicMT;}
{\colortbl;\red255\green255\blue255;\red0\green0\blue255;}
\paperw11900\paperh16840\margl1440\margr1440\vieww25100\viewh15040\viewkind0
\deftab720
\pard\pardeftab720

\f0\fs26 \cf2 \
\pard\pardeftab720

\f1\i\b \cf0 \ul \ulc0 Tabelle waehler
\f0\i0\b0 \cf2 \ulnone \
CREATE\cf0  \cf2 TABLE\cf0  waehler (ID \cf2 int\cf0  \cf2 GENERATED\cf0  \cf2 BY\cf0  \cf2 DEFAULT\cf0  \cf2 AS\cf0  \cf2 IDENTITY\cf0  (\cf2 start\cf0  \cf2 with\cf0  1, increment \cf2 by\cf0  1) \cf2 not\cf0  \cf2 null\cf0  \cf2 primary\cf0  \cf2 key\cf0 ,\
VORNAME \cf2 varchar\cf0 (50) \cf2 not\cf0  \cf2 null\cf0 ,\
\pard\pardeftab720
\cf2 NAME\cf0  \cf2 varchar\cf0 (50) \cf2 not\cf0  \cf2 null\cf0 ,\
AUSWEISNR \cf2 varchar\cf0 (20),\
PASSWORT \cf2 varchar\cf0 (10),\
WAHLKREIS varchar(50),\
STATUS \cf2 varchar\cf0 (20));\
\
\pard\pardeftab720

\f1\i\b \cf0 \ul \ulc0 Tabelle stimmenkandidat
\f0\i0\b0 \ulnone \
\pard\pardeftab720
\cf2 CREATE\cf0  \cf2 TABLE\cf0  stimmenkandidat (ID \cf2 int\cf0  \cf2 GENERATED\cf0  \cf2 BY\cf0  \cf2 DEFAULT\cf0  \cf2 AS\cf0  \cf2 IDENTITY\cf0  (\cf2 start\cf0  \cf2 with\cf0  1, increment \cf2 by\cf0  1) \cf2 not\cf0  \cf2 null\cf0  \cf2 primary\cf0  \cf2 key\cf0 ,\
KANDIDAT \cf2 varchar\cf0 (50) \cf2 not\cf0  \cf2 null\cf0 ,\
PARTEI \cf2 varchar\cf0 (50) \cf2 not\cf0  \cf2 null\cf0 ,\
WAHLKREIS \cf2 varchar\cf0 (50),\
STIMMEN \cf2 int\cf0  \cf2 not\cf0  \cf2 null\cf0 );\
\
\pard\pardeftab720

\f1\i\b \cf0 \ul \ulc0 Tabelle stimmenpartei
\f0\i0\b0 \ulnone \
\pard\pardeftab720
\cf2 CREATE\cf0  \cf2 TABLE\cf0  stimmenpartei (ID \cf2 int\cf0  \cf2 GENERATED\cf0  \cf2 BY\cf0  \cf2 DEFAULT\cf0  \cf2 AS\cf0  \cf2 IDENTITY\cf0  (\cf2 start\cf0  \cf2 with\cf0  1, increment \cf2 by\cf0  1) \cf2 not\cf0  \cf2 null\cf0  \cf2 primary\cf0  \cf2 key\cf0 ,\
PARTEI \cf2 varchar\cf0 (50) \cf2 not\cf0  \cf2 null\cf0 ,\
WAHLKREIS \cf2 varchar\cf0 (50),\
STIMMEN \cf2 int\cf0  \cf2 not\cf0  \cf2 null\cf0 );\
\

\f1\i\b \cf2 \ul \ulc2 Tabelle wahlkreise
\f0\i0\b0\fs28 \ulnone \
CREATE\cf0  \cf2 TABLE\cf0  wahlkreise (WAHLKREISNUMMER \cf2 int\cf0  \cf2 not\cf0  \cf2 null\cf0 ,\
WAHLKREISNAME \cf2 varchar\cf0 (50));}